12. Redshift ETL Examples

L03-05-Part 2 Redshift ETL Examples

If you have multiple files that belong to the same table names as follows:

  • s3://mySource/day1-sales.csv.gz
  • s3://mySource/day2-sales.csv.gz

Which method are you going to use to ingest the files from S3 into Redshift?

SOLUTION: I would create a manifest file